const Sequelize = require('sequelize');
module.exports = function(sequelize, DataTypes) {
  return sequelize.define('base_construction_licence_attached', {
    id: {
      autoIncrement: true,
      type: DataTypes.BIGINT,
      allowNull: false,
      primaryKey: true,
      comment: "唯一标识"
    },
    messageId: {
      type: DataTypes.STRING(64),
      allowNull: true,
      comment: "原信息ID",
      field: 'message_id'
    },
    persionPromise: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "劳保是否承诺",
      field: 'persion_promise'
    },
    supportexpPromise: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "配套费是否承诺",
      field: 'supportexp_promise'
    },
    nmsPdomise: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "扬尘办是否承诺",
      field: 'nms_pdomise'
    },
    tankanDdomise: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "踏勘是否承诺",
      field: 'tankan_ddomise'
    },
    laborDdomise: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "劳务工资保证金是否承诺",
      field: 'labor_ddomise'
    },
    supportexpPromiseStatus: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "配套费承诺状态",
      field: 'supportexp_promise_status'
    },
    persionPromiseStatus: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "养老保障金承诺状态",
      field: 'persion_promise_status'
    },
    nmsPdomiseStatus: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "扬尘办是否承诺状态",
      field: 'nms_pdomise_status'
    },
    tankanDdomiseStatus: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "踏勘是否承诺状态",
      field: 'tankan_ddomise_status'
    },
    laborDdomiseStatus: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "劳务合同是否承诺制状态",
      field: 'labor_ddomise_status'
    },
    sendOfficeDate: {
      type: DataTypes.STRING(25),
      allowNull: true,
      comment: "联办发送时间",
      field: 'send_office_date'
    },
    officeDate: {
      type: DataTypes.STRING(25),
      allowNull: true,
      comment: "联办时间",
      field: 'office_date'
    },
    officeOpinion: {
      type: DataTypes.TEXT,
      allowNull: true,
      comment: "联办意见",
      field: 'office_opinion'
    },
    evaluate1: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "毗邻高压线的状况有无结论"
    },
    resolve1: {
      type: DataTypes.STRING(200),
      allowNull: true,
      comment: "描述1"
    },
    evaluate2: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "工对毗邻建筑物构筑物（含围挡墙、护坡、挡土墙）的影响"
    },
    resolve2: {
      type: DataTypes.STRING(200),
      allowNull: true,
      comment: "描述2"
    },
    evaluate3: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "靠近山体、水体、油库、地下管线、坑道、堤坝、危险品库、军事设施、测量标志的状况"
    },
    resolve3: {
      type: DataTypes.STRING(200),
      allowNull: true,
      comment: "描述3"
    },
    evaluate4: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "深基坑施工对周边环境的影响"
    },
    resolve4: {
      type: DataTypes.STRING(200),
      allowNull: true,
      comment: "描述4"
    },
    evaluate5: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "施工对周边通信、道路等公用设施的影响"
    },
    resolve5: {
      type: DataTypes.STRING(200),
      allowNull: true,
      comment: "描述5"
    },
    evaluate6: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "施工现场的临建设施选址是否合理，结构是否安全，围挡墙是否牢固可靠"
    },
    resolve6: {
      type: DataTypes.STRING(200),
      allowNull: true,
      comment: "描述6"
    },
    evaluate7: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "施工现场对周边交通、行人、集贸市场和学校等人流密集区域的影响"
    },
    resolve7: {
      type: DataTypes.STRING(500),
      allowNull: true,
      comment: "描述7"
    },
    evaluate8: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "施工中各种粉尘、废气、废水、固体废弃物以及噪音、振动对环境的污染和危害"
    },
    resolve8: {
      type: DataTypes.STRING(200),
      allowNull: true,
      comment: "描述8"
    },
    evaluate9: {
      type: DataTypes.STRING(10),
      allowNull: true,
      comment: "其他可能造成严重后果的危险源"
    },
    resolve9: {
      type: DataTypes.STRING(200),
      allowNull: true,
      comment: "描述9"
    },
    isDeleted: {
      type: DataTypes.TINYINT,
      allowNull: true,
      comment: "是否删除",
      field: 'is_deleted'
    },
    createdUser: {
      type: DataTypes.BIGINT,
      allowNull: true,
      comment: "创建人",
      field: 'created_user'
    },
    createdTime: {
      type: DataTypes.DATE,
      allowNull: true,
      comment: "本系统创建时间",
      field: 'created_time'
    },
    updatedUser: {
      type: DataTypes.BIGINT,
      allowNull: true,
      comment: "修改人",
      field: 'updated_user'
    },
    updatedTime: {
      type: DataTypes.DATE,
      allowNull: true,
      comment: "修改时间",
      field: 'updated_time'
    }
  }, {
    sequelize,
    tableName: 'base_construction_licence_attached',
    timestamps: false,
    indexes: [
      {
        name: "PRIMARY",
        unique: true,
        using: "BTREE",
        fields: [
          { name: "id" },
        ]
      },
    ]
  });
};
